#! /bin/bash
export LANG=zh_CN.UTF-8
HIVE_HOME=/usr/bin/hive


${HIVE_HOME} -S -e "
--有效线索个数
--数据问题，只采集有效线索个数作为计算使用
INSERT INTO edu_online_dwd.fac_valid_clue
SELECT
count(*) AS valid_clue_count
FROM edu_online_ods.customer_appeal
WHERE appeal_status = 2;

--校区学科维度表
INSERT INTO edu_online_dwd.dim_campus_subject
SELECT
    id,
    create_date_time,
    update_date_time,
    deleted,
    itcast_school_id,
    itcast_school_name,
    itcast_subject_id,
    itcast_subject_name,
    itcast_brand,
    clazz_type_state,
    clazz_type_name,
    teaching_mode,
    start_time,
    end_time,
    comment,
    detail,
    uncertain,
    dt
FROM edu_online_ods.itcast_clazz
"